package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_Primary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "otp_record", simpleName = "", engine = MysqlDriver.InnoDB, comment = "")
public class _DDL_OtpRecord {

    @_DDL_Column(name = "OTP_SCENE", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "场景值")
    private String scene;

    @_DDL_Column(name = "USE_STATUS", type = SqlType.INT, nullable = false, comment = "使用状态，0：未使用、1：已使用")
    private Integer useStatus;

    @_DDL_Column(name = "OTP_PHONE", type = SqlType.VARCHAR, size = 11, nullable = false, comment = "手机号")
    private String phone;

    @_DDL_Primary()
    @_DDL_Column(name = "OTP_KEY", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "键")
    private String key;

    @_DDL_Column(name = "OTP_VALUE", type = SqlType.VARCHAR, size = 10, nullable = false, comment = "值")
    private String value;

    @_DDL_Column(name = "OTP_CONTENT", type = SqlType.VARCHAR, size = 100, nullable = false, comment = "内容")
    private String content;

    @_DDL_Column(name = "CREATE_TIME", type = SqlType.VARCHAR, size = 19, nullable = false, comment = "创建时间")
    private String createTime;

    @_DDL_Column(name = "VALID_TIME", type = SqlType.VARCHAR, size = 19, nullable = false, comment = "有效时间")
    private String validTime;

}
